﻿<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>SSICA in Visalia, CA is Scan Student Identification Card Authorization program.</title>
    <meta content="text/html; charset=utf-8" http-equiv="content-type" />
    <meta content="IE=7,chrome=1,IE=9" http-equiv="X-UA-Compatible" />
    <meta name="description" content="SSICA in Visalia, CA is Scan Student Identification Card Authorization program that allows schools and universities to use smartphones to scan students ID card to track student activity." />
    <meta name="keywords" content="SSICA,Visalia CA,Scan Student Identification Card Authorization,smartphone,students ID card,scan,school officials,monitor,scanning,ID card" />
    <meta charset="UTF-8">
    <meta name="viewport" content="initial-scale=1.0,width=device-width" />
    <meta name="format-detection" content="telephone=no" />

    <style type="text/css">
        .untrustedWidgetFrame {
            width: 300px;
            height: 200px;
            border: 0;
        }
    </style>
    <link rel="stylesheet" href="/Content/main.css" />
    <link rel="stylesheet" href="/Content/site.1374689053.css" />
    <link rel="stylesheet" href="/Content/public.1370981463.css" />
    <link rel="stylesheet" href="/Content/account.1372691420.css" />
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.18/jquery-ui.min.js"></script>
    <script src="https://ajax.aspnetcdn.com/ajax/jquery.validate/1.10.0/jquery.validate.min.js"></script>
    <script src="/Scripts/respond.min.js"></script>
    <script src="/Scripts/main.js"></script>
    <script src="/Scripts/modernizr.js" type="text/javascript"></script>

    <style type="text/css">
        .cm-logo {
            background-color: !important;
            background-image: url("Content/Images/logo.png");
            background-position: 21px 3px !important;
            background-repeat: no-repeat !important;
        }
    </style>
    <script type="text/javascript">
        var cmLogoWidgetId = "HOP1_cm4all_com_widgets_Logo_2726688";
        var cmLogoGetCommonWidget = function () {
            return new cm4all.Common.Widget({
                base: "/Default.aspx",
                session: "",
                frame: "",
                path: "HOP1_cm4all_com_widgets_Logo_2726688"
            })
        };
        var logoConfiguration = {
            "cm-logo-x": 21,
            "cm-logo-y": 130,
            "cm-logo-v": "2.0",
            "cm-logo-w": 169,
            "cm-logo-h": 100,
            "cm-logo-u": "Content/Images/",
            "cm-logo-k": "/logo.png",
            "cm-logo-bc": "",
            "cm-logo-hi": false
    ,
            _logoBaseUrl: '/Content/Images/',
            _logoPath: 'logo.png'
        };
    </script>


</head>

<!--[if (gte IE 6)&(lte IE 7)]><body class="ie"><![endif]-->
<body>
    <div id="wrapper">
        <header id="banner">
            <div class="bannermain">
                <div id="dvout">
                    <ul id="util-out">
                        <li><a href="mailto:support@ssica.org" class="mobile_enabled">Contact</a></li>
                        <li id="last"><a href="/Default.aspx" title="Sign In">Sign In</a></li>
                        <li><a href="/Register.aspx" title="Create Account">Create Account</a></li>
                    </ul>
                </div>
            </div>

            <div id="logo_wrapper">
                <div id="logo_bg">
                    <div id="logo_middle">
                        <div title="SSICA - Scanning and Safety Go Hand-In-Hand" id="logo" class="cm-logo">
                            <div id="title_wrapper">
                                <h1 id="title">Your company</h1>
                                <h2 id="subtitle">Please enter your slogan here</h2>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div id="head_wrapper">
                <div class="bg_top4">
                    <div class="bg_y4">
                        <div class="bg_y5">
                            <div class="bg_bottom4">
                                <div id="cm_navigation">
                                    <ul id="cm_mainnavigation">
                                        <div id="guestMenu">
                                            <li><a href="http://drssica.com/Home/" title="How It Works"><b>Home</b></a></li>
                                            <li><a href="http://drssica.com/Plans-and-Pricing/" title="What Does It Cost?" target="_blank"><b>Plans</b></a></li>

                                        </div>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </header>
        <div class="contentfull">
            <div class="breadcrumbs">
                <ul id="crumbs">
                    <li><a title="SSICA" href="/">Home</a>  <img src="/Content/Images/separator.png" alt="&rarr;" class="separator">How To? </li>
                </ul>
            </div>
            <div id="showMessages"></div>
            <div class="main_a">
                <div class="top">
                    <h1>How To?</h1>
                </div>
                <div class="container_x">
                    <div class="kb_sidebar">
                        <ul class="kb_menu">
                            <li><a id="category_3" href="users.html"> <img src="../Images/user48.png" />Staffs</a></li>
                            <li><a id="category_4" href="/HowTo/"> <img src="../Images/service48.png" />Buttons</a></li>
                            <li><a id="kb_active" href="database.html"> <img src="../Images/database-normal.png" />Rosters</a></li>
                            <li><a id="category_6" href="scans.html"> <img src="../Images/scan48.png" />Scans</a></li>
                        </ul>
                        <br />
                    </div>
                    <div class="f_container_a">
                        <header>
                            <h2>Creating A Roster</h2>
                        </header>

                        <article class="kb-article">
                            <div>
                                <p>Validation Rosters enable the  app to check if the value of a scanned barcode(student) exists in that Roster. If it does, it will return a Valid message to the app Staff and any related information (the &#39;Response&#39; text). If the value is not in the Roster it will return an Invalid message or Invalid Duplicate, if so enabled.</p>
                                <p>Examples: <br /> * Verify if a student&#39;s ID is valid</p><br />
                                <p>
                                    <img src="Images/db1.png" alt="Create_Database.png" /><br /><br />
                                    Step 1: Click &#39; <em> Create a Roster </em> &#39; <br />
                                    Step 2: Enter a Name for your Roster <br />
                                    Step 3: [OPTIONAL] import values from a CSV file.<br />
                                    Step 4: Click &#39; <em> Create Roster </em> &#39; <br /> <img src="Images/db2.png" alt="Create_a_Database1.png" />
                                </p>
                                <p>
                                    Once you&#39;ve created a Roster, Staffs can do the following: <br />
                                    1. Add Data<br />
                                    2. Edit Data<br />
                                    3. Delete Data<br />
                                    4. Search Data<br />
                                </p>
                                <h3>Creating CSV file for Roster Import</h3>
                                <p>
                                    SSICA supports the extension .CSV (Comma Separated Values) to quickly add details to a Roster. These CSV files must meet the standards below. Not following this format will result in an upload failure. Also, It is recommended that header lines should not be used, as they will also import as a separate entry.
                                </p>
                                <p><strong>Note: that CSV files that've been exported from the Scan page can't be directly imported into a Roster. SSICA.com will not accept CSV files with more than 9 columns !</strong></p>

                                <strong> Requirements</strong>
                                <table class="tableinfo">
                                    <tbody>
                                        <tr><th>Required&nbsp;</th><th>Column</th><th>Description</th></tr>
                                        <tr>
                                            <td style="color: red;"><strong> Yes </strong></td>
                                            <td>1</td>
                                            <td><strong> Student Id Number </strong> -Integer value. 2,147,483,647 is the limit</td>
                                        </tr>
                                        <tr>
                                            <td style="color: red;"><strong> Yes </strong></td>
                                            <td>2</td>
                                            <td><strong> First Name </strong> - Student First Name. 250 character is the limit</td>
                                        </tr>
                                        <tr>
                                            <td>No</td>
                                            <td>3</td>
                                            <td><strong> Last Name </strong> -Student Last Name (Optional). 250 character is the limit</td>
                                        </tr>
                                        <tr>
                                            <td>No</td>
                                            <td>4</td>
                                            <td><strong> Grade </strong> -Student Grade (Optional. Integer value is allowed.</td>
                                        </tr>
                                        <tr>
                                            <td style="color: red;"><strong> Yes </strong></td>
                                            <td>5</td>
                                            <td><strong> Validity </strong> -Status of the value when scanned. 
                                            <br> "1" for an invalid response. 
                                            <br> "2" for a valid response. 
                                            <br> "3" for a lunch detention response. 
                                            <br> "4" for a saturday school response. 
                                            <br> <strong> Invalid </strong> by default. (even if Column E(Validity) has a value that is not 0 or 1)</td>
                                        </tr>
                                        <tr>
                                            <td>No</td>
                                            <td>6</td>
                                            <td><strong> Note1 </strong> -Note for the scan. 250 character is the limit</td>
                                        </tr>
                                        <tr>
                                            <td>No</td>
                                            <td>7</td>
                                            <td><strong> Note2 </strong>  -Note for the scan. 250 character is the limit</td>
                                        </tr>
                                        <tr>
                                            <td>No</td>
                                            <td>8</td>
                                            <td><strong> Note3 </strong>  -Note for the scan. 250 character is the limit</td>
                                        </tr>
                                        <tr>
                                            <td>No</td>
                                            <td>9</td>
                                            <td><strong> Note4 </strong>  -Note for the scan. 250 character is the limit</td>
                                        </tr>
                                    </tbody>
                                </table>

                                <strong>Creating CSV file using Microsoft Excel</strong>
                                <br />Use microsoft excel to create csv file for uploading into the system. See below image to create the file.<br/>
                                <img src="Images/excel.png" alt="Create_Database.png" /><br /><br />
                                <strong>Creating CSV file using notepad</strong>
                                <ol>
                                    <li> On 1 line enter: StudentIdNumber,FirstName,LastName,Grade,Validity,Note1,Note2,Note3,Note4 Separated by commas ( , ) </li>
                                    <li>Repeat Step 1 on new lines until finished</li>
                                </ol>
                                See the below image.<br />
                                <img src="Images/notepad.png" alt="Create_Database.png" /><br /><br />
                                Now save the notepad file you created in the csv formate as shown below
                                <br />
                                <img src="Images/notepad1.png" alt="Create_Database.png" /><br /><br />

                            </div>
                        </article>

                        <!-- Article Categories Listing -->

                        <hr class="greyline">
                        <!-- Related Articles -->

                    </div>
                </div>
            </div>



        </div> <!-- /.contentfull -->
    </div> <!-- /.wrapper -->
    <footer>
        <div class="clearer">&nbsp;</div>
        <div class="footer">
            <div class="f_wrap">
                <div id="footer">
                    <a href="http://drssica.com/Home/">Home</a> | <a href="http://drssica.com/About-Us/">About Us</a> | <a href="http://drssica.com/Why-SSICA/">Why SSICA?</a> | <a href="http://drssica.com/Plans-and-Pricing/">Plans and Pricing</a> | <a href="http://drssica.com/Features/">Features</a> | <a href="http://drssica.com/FAQ/">FAQ</a> |<a href="Terms.html" target="_blank">Terms & Conditions</a>| <a href="http://drssica.com/Contact/">Contact</a>

                    <p>Copyright © 2013 SSICA. All rights reserved.</p>
                </div>
            </div>
        </div>

    </footer>

</body>
</html>
